Note: This statement is named Last Recordset Row in the Add Statement dialog box.
Makes the last row in a recordset the active row.
Syntax
LastRow(Recordset)
Arguments
Argument | Description |
---|---|
Recordset | Recordset name. Must be opened with OpenRecordset or OpenRecordsetQuery. |
Example
rs = OpenRecordset("WysiCorp Bugs (Excel)")
LastRow(rs)
While Not RecordsetBOF(rs)
PrintLn(GetRowValue(rs, "First Name"))
PrevRow(rs)
WEnd